An opulent, carefully restored, 18th-century castle in Ireland has been named the hotel of the year by experts at luxury travel network Virtuoso.